/*****************************************************************************
 *
 *                      HUSONG PROPRIETARY INFORMATION
 *
 *          The information contained herein is proprietary to HUSONG
 *           and shall not be reproduced or disclosed in whole or in part
 *                    or used for any design or manufacture
 *              without direct written authorization from HUSONG.
 *
 *            Copyright (c) 2015 by HUSONG.  All rights reserved.
 *
 *****************************************************************************/
package me.send.data.service.mapper;

import java.util.List;

import me.send.data.service.pojo.ActivitySchoolFastfood;

import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

/**
 * @author maxmin
 *
 * @date 2015年10月21日 下午5:03:38
 */
public interface ActivitySchoolFastfoodMapper {
	@Select(value="SELECT * FROM activity_school_fastfood WHERE isdelete=0")
	@Results({
		@Result(column="fastfood_id",property="fastfoodId"),
		@Result(column="school_name",property="schoolName"),
		@Result(column="pic_path",property="picPath"),
		@Result(column="discount_price",property="discountPrice")
	})
	public abstract List<ActivitySchoolFastfood> getActivitySchoolFastfood();
	
	
	@Select(value="SELECT * FROM activity_school_fastfood WHERE isdelete=0 AND fastfood_id =#{id} LIMIT 1")
	@Results({
		@Result(column="fastfood_id",property="fastfoodId"),
		@Result(column="school_name",property="schoolName"),
		@Result(column="pic_path",property="picPath"),
		@Result(column="discount_price",property="discountPrice")
	})
	ActivitySchoolFastfood getActivitySchoolFastfoodById(Long id);
}
